﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using TugasAkhir.Helpers;

namespace TugasAkhir.Models
{
    public static class PengambilanMahasiswaModel
    {
        public static bool GetPengambilanMatakuliah(string periode, string tahun, out DataSet hasilQuery)
        {
            string query = String.Format("SELECT [kelas], [periode], [tahun], [id_matakuliah], [id_mahasiswa] FROM [dbo].[pengambilan_mahasiswa] WHERE [periode] = '{0}' AND [tahun] = '{1}'", periode, tahun);
            return SqlServer.ExecuteReader(query, out hasilQuery);
        }
    }
}